###out:src/main/${config.mapperXMLDirectoryName}/${config.modulePackageName}/${root.beanName}Mapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="${config.basePackageName}.${config.daoPackageName}.${config.modulePackageName}.${root.beanName}Mapper">
    <resultMap id="EntityMapper" type="${config.basePackageName}.${config.entityPackageName}.${config.modulePackageName}.${root.beanName}" >
    <#list root.tableColumns as column>
        <#if column.primaryKey>
            <id column="${column.columnName}" property="${column.propertyName}" jdbcType="${column.jdbcType}" />
        <#else>
            <result column="${column.columnName}" property="${column.propertyName}" jdbcType="${column.jdbcType}" />
        </#if>
    </#list >
    </resultMap>
    <insert id="insert">
        INSERT into ${root.tableName} (
        <#list root.tableColumns as column>
            "${column.columnName}"<#if column_has_next>,</#if>
        </#list >
        )
        VALUES (
        <#list root.tableColumns as column>
            ${r'#{'}${column.propertyName}${r'}'}<#if column_has_next>,</#if>
        </#list >
        );
    </insert>
    <update id="update">
        update ${root.tableName} set
        <#list root.tableColumns as column>
        <#if column.columnName != 'id' >
            "${column.columnName}" = ${r'#{'}${column.propertyName}${r'}'}<#if column_has_next>,</#if>
        </#if>
        </#list >
        where id = ${r'#{id}'}
    </update>
    <delete id="delete">
        delete from ${root.tableName} where id = ${r'#{id}'}
    </delete>
    <select id="get" resultMap="EntityMapper">
        select * from ${root.tableName} where id = ${r'#{id}'}
    </select>
    <update id="recovery">
        update ${root.tableName} set activate = true ,update_time = now(),updater = ${r'#{operator}'} where id = ${r'#{id}'}
    </update>
    <update id="trash">
        update ${root.tableName} set activate = false ,update_time = now(),updater = ${r'#{operator}'} where id = ${r'#{id}'}
    </update>
</mapper>